hwo to use REGEXP to find rows with any numbers in between?

[poolboi]

hey guys,

i got a question on REGEXP in SQL

if i have a row containing the info

NAME : 12344455667678

how can i use a SELECt with REGEXP
[CODE=mysql]
SELECT * FROM `mml log` WHERE Commands REGEXP
[/CODE]

such that it will search anything in the field with NAME : $input
in which the $input is given by my users

so say is $input is 234 or 444 or 5566
it will still return me the row containing the info above?

[r035198x]

You don't need REGEXP for that. Just a simple like with the % wildcard will do.
If you insist on REGEXP then you can read about how to use it from here.

[poolboi]

hm...i tried using wild card too

the reason why it doesn't work is 'cos
i want to make sure the number is attached to NAME

so if i have 2 rows each containing;

NAME :11223345565
CLASS: 18373556879

if i use use wild card with %556%
it's gonna return both the rows
but i only want it attached with NAME

[r035198x]

hm...i tried using wild card too

the reason why it doesn't work is 'cos
i want to make sure the number is attached to NAME

so if i have 2 rows each containing;

NAME :11223345565
CLASS: 18373556879

if i use use wild card with %556%
it's gonna return both the rows
but i only want it attached with NAME

I'm missing something here.
Are NAME and CLASS two different columns?

[r035198x]

I'm missing something here.
Are NAME and CLASS two different columns?

Wait, I think I get you now.
You can use concat. Concat 'NAME' with the wild carded input.

[Atli]

If you have "NAME :11223345565" in a single field, you shouldn't!
You should never have two pieces of data inside the same field.
Check out this article.

If that is how it is tho, you could simply do:

SELECT * FROM tbl WHERE col LIKE "NAME: %345%"

The wild-cards can be anywhere inside a string, not just at the ends.

[r035198x]

..
You should never have two pieces of data inside the same field.
...

Amen .

[poolboi]

hm.i get what u mean
by right it should be under a column name

actualli that field of mine is called commands
commands that ppl use during a telnet session
sometimes commands can be very long with number
and i just wanna query say wildcard the number and get the results

with regards to
[CODE=mysql]

NAME = %345%
[/CODE]

i've tried and doesn't worked too..

[r035198x]

hm.i get what u mean
by right it should be under a column name

actualli that field of mine is called commands
commands that ppl use during a telnet session
sometimes commands can be very long with number
and i just wanna query say wildcard the number and get the results

with regards to
[CODE=mysql]

NAME = %345%
[/CODE]

i've tried and doesn't worked too..

Wildcards are used with the LIKE operator not the = operator.
Also I think you want to do

 LIKE 'NAME:%345%'