| We hope you enjoy your visit. You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. Join our community! If you're already a member please log in to your account to access all of our features: |
| PHP Loose Matching | |
|---|---|
| Tweet Topic Started: Sep 26 2008, 04:03 PM (531 Views) | |
| Viral. | Sep 26 2008, 04:03 PM Post #1 |
![]()
Member
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
|
How can I use loose matching in a mysql query? I have tried:
but that only allowed for perfect, non case sensitive matching. |
![]() |
|
| mcteeth | Sep 26 2008, 07:33 PM Post #2 |
|
Oh, Comely.
![]() ![]() ![]() ![]()
|
Use wildcards:
This matches "test" and any string with "test" in it. %test and test% do the same with the exception that "test" is either at the end or the beginning of the string. Edited by mcteeth, Sep 26 2008, 07:36 PM.
|
![]() |
|
| Viral. | Sep 28 2008, 10:10 AM Post #3 |
![]()
Member
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
|
Thanks mcteeth .
|
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Technology Chat · Next Topic » |
| Track Topic · E-mail Topic |
3:17 PM Jul 11
|




![]](http://b1.ifrm.com/0/1/0/p601690/pipright.png)



.
3:17 PM Jul 11