Need your help in a search query

2003-06-26 Thread Tom Johnson
his on the web using PHP and MySQL. Possible someone knows of a good search script in PHP that might help also? Here is the query I was trying to run: SELECT * FROM ardata WHERE title LIKE '%user_input%'; I am using MySQL 4.0.13 and PHP 4.3.2 Thanks for helping! Tom Johnson --

MySQL and running a function similar to PATINDEX()

2003-06-16 Thread Tom Johnson
;% %', name ) + 1, LEN ( name )), fname = SUBSTRING ( author, PATINDEX ( '% %', name )); Thanks, Tom Johnson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]