I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing.
The database I have created needs to store Documents and I have used Blob type columns for this. If I want to:
Select USERID,NAME,LNAME Where DOC contains "what ever words or phrases" ;
How would I do this ?
Many thanks for information on this.
Here from you soon I hope, Best regards Andy Fletcher
Andy,
You probably want to use FullText searching on text fields which is much faster than using wild card searches using LIKE '%something%'. Please see the manual http://www.mysql.com/doc/en/Fulltext_Search.html.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]