$sql = mysql_query("
SELECT
p.title, SUBSTR(p.post,1,300) as post
FROM Posts p
WHERE p.title LIKE '%{$q}%' OR p.post LIKE '%{$q}%'
");
Code:
CREATE TABLE IF NOT EXISTS `mydb`.`Posts` (
`idPosts` INT NOT NULL AUTO_INCREMENT ,
`title` CHAR(155) NOT NULL ,
`post` TEXT NOT NULL ,
PRIMARY KEY (`idPosts`) );