Welcome, Guest. Please login or register.
Did you miss your activation email?
Jan 06, 2009, 02:33:20 AM

I cannot give you the formula for success, but I can give you the formula for failure--which is: Try to please everybody.

- Herbert Bayard Swope

Home

Help

Welcome Guest - Register or Login Now to remove these advertisments

Registration is completely free and only takes a few minutes to signup !

Entrepreneur Forum > Webmasters - Discuss Making Money Online > Website Design and Maintenance > Database

MYSQL wildcards not working ??

0 Members and 1 Guest are viewing this topic.

Pages: [1]

Author

Topic: MYSQL wildcards not working ?? (Read 347 times)

Galaxian

Senior Member

Joined: Oct 2007
Posts: 238

The internet is my playground.

$View Galaxian\s Profile$
Gender: Male

United States

Nov 24, 2007, 11:52:21 PM

Hello,

Any thoughts on this would be appreciated.

Trying to return records using a wildcard. I thought this would return matches for 10, 11, 12 etc., but it doesn't.

mysql_query("SELECT * FROM table_name WHERE column1 = '1*' " )

Thanks

Latest Blog Post : The Advantages of Water-Powered Car Technology

Got an eye for The Best Cars like a sizzling Ferrari sports car or the luxury of BMW?

~Dave~

Administrator

Joined: Jan 2006
Posts: 6186

Building a Foundation

$View ~Dave~\s Profile$

United States

Nov 26, 2007, 01:26:41 PM

First, you have to use the "LIKE" statement instead of the "=" when using wildcards, and second, the wildcard character is % not *

ie : mysql_query("SELECT * FROM table_name WHERE column1 LIKE '1%' " )

Latest Blog Post : Social Media Optimization for Social Media Marketing

Best Affiliate Programs Ξ Recommend Us Ξ Blogger Forum

Pages: [1]