Posted by Andre Dubuc on 10/04/41 11:09

On Friday 25 February 2005 04:28 pm, Wiberg wrote:
> Hi there!
>
> A little off-topic but what the heck (it's a more MySQL - related question)
>
> Is 197* a numbertype field?
> Try maybe $query= "SELECT * FROM my_table WHERE Year LIKE '197*'";
>
> /G
> @varupiraten.se
>
> -----Ursprungligt meddelande-----
> Från: David Freedman [mailto:eatc7402@comcast.net]
> Skickat: den 25 februari 2005 21:28
> Till: php-general@lists.php.net
> Ämne: [PHP] Difficulty with SQL LIKE clause
>
>
> When I use this query in PHP it works, and I get all things with the YEAR
> of 1977, as I expected.
>
> $query= "SELECT * FROM my_table WHERE Year LIKE 1977 ";
>
> But, when I use this query it does not work.
>
> $query= "SELECT * FROM my_table WHERE Year LIKE 197* ";
>
> I thought I should get the result of ALL things with the years in the
> 1970's (1970-1979). But the asterisk in the LIKE clause does not seem to
> work. I have tried various syntax's to try to get the 197* recognized but
> without any luck.
>
> Can the '*' be used? What am I doing wrong.
>
> David F.


Try:

$query= "SELECT * FROM my_table WHERE year ~* '^(197).*'";

Hth,
Andre

• Prev in thread: Re: [PHP] Difficulty with SQL LIKE clause
• Next in forum: Re: [PHP] [NEWBIE] How to allow for <a href> tags but no others?
• Prev in forum: Re: [PHP] what does this mean?
• Thread view: Difficulty with SQL LIKE clause

[Reply to this message]