[SOLVED] MYSQL any single character

[Guest]

I want to make a query that selects any one character

 

example

 

I want to select

 

123

but not

1234

 

I have tried this 12% but this brings up both I just want 12any single character

 

How can I do this?

[rarebit]

Not quite sure what you want but try str_split(), http://uk3.php.net/manual/en/function.str-split.php

$s = "1234";
$a = str_split($s);
echo $a[0];

or

$s = "1234";
$a = str_split($s, 3);
echo $a[0];

[HuggieBear]

Use an underscore (_) it's the SQL wild card for single character.

 

SELECT column FROM table WHERE column LIKE '12_'

 

Regards

Huggie

[Guest]

Thank you the underscore did it exactly thank you