How do I create a keyword search in MySQL? — OZONE Asylum, home of the Mad Scientists

FAQ

How do I create a keyword search in MySQL?

This page's ID: 5481

You are editing "How do I create a keyword search in MySQL?"

Who can edit an FAQ?	Anyone registered may edit an FAQ.

Your User Name:
Your Password:
Login Options:	Remember Me On This Computer

Your Text: Insert Slimies » Insert UBB Code » Close Last Tag \| All Tags UBB Help	You need to use something like: [code]LIKE '%$search%'[/code] and there are many alternatives like using REGEXP for regular expression-based searching. Note: LIKE is case insensitive. --------------------------- Relevant links: [url=http://www.mysql.com/doc/en/String_comparison_functions.html]String Comparison Functions[/url] - explains the LIKE syntax. [url=http://www.mysql.com/doc/en/Fulltext_Search.html]MySQL Full-text Search[/url] - explains another possible approach using MATCH and AGAINST. --------------------------- Relevant FAQs: [internallink=5747]How do I do a search and replace on entries in my MySQL database?[/internallink] ________________________ [internallink=4626]Emperor[/internallink] [small][i](Added by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Mon 09-Dec-2002)[/i][/small] [small][i](Edited by: [url=http://www.ozoneasylum.com/cgi-bin/ubbmisc.cgi?action=getbio&UserName=Emperor]Emperor [/url] on Tue 08-Jul-2003)[/i][/small] Loading...
Options:	Enable Slimies Enable Linkwords

« Backwards — Onwards »

Show Forum Drop Down Menu