[I Want to search more in LIKE CLAUSE..]

You can also use

 

MATCH `field` AGAINST('{$query}')

 

Which is alot faster than scanning the database with

 

`field` like '%{$query}%'

 

 

who says it's faster? do you have proof? your nothing to me w/o proof

 

HA! nice try - im not writing the script for you.

 

The only proof you need is my experience with large databases

 

?? I'm not looking for the exact find anyway, your are nothing to me (Im talking about your post) when u decide to put in a statement that might be biased, sorry.

[I Want to search more in LIKE CLAUSE..]

You can also use

 

MATCH `field` AGAINST('{$query}')

 

Which is alot faster than scanning the database with

 

`field` like '%{$query}%'

 

who says it's faster? do you have proof? your nothing to me w/o proof

[I Want to search more in LIKE CLAUSE..]

$search = "`title` LIKE '%Silvin AND wts%'";

 

I want to search for both of those keywords why not work?