mysql start of word

[The Little Guy]

anyone know how to search for something starting with a number in mysql?

 

and is there a way to find something starting with a symbol?

 

I have this, which doesn't work:

users.displayName LIKE '0-9%'

 

but these work individually:

users.displayName LIKE '0%'

users.displayName LIKE '1%'

users.displayName LIKE '2%'

and so on, but that doesn't work for me, I need to have it so it will find everything starting with a number on the first search, same thing with symbols.

[teng84]

dude use the [^a-z0-9]

 

heard about that wild char of sql that will do

[The Little Guy]

users.displayName LIKE '[^0-9]%'

or

users.displayName LIKE '[^0-9]'

 

neither of these work.

[clearstatcache]

try ds....

 

users.displayName REGEXP '[^0-9]%'

[The Little Guy]

nope

[clearstatcache]

try ds....

 

users.displayName REGEXP '^[0-9]'

 

[The Little Guy]

There we go... that worked, now How would I do symbols?

 

for users.displayName?

[clearstatcache]

do you want to get the names starting with a specific symbol or whatever symbols?

 

[The Little Guy]

names starting with any symbol

[clearstatcache]

try ds.....

users.displayName REGEXP '^.'

 

ds will get all the names whatever it start....

[The Little Guy]

nope, that grabs everyone.

 

OK... I have links, that you can browse users, you can search by the following:

- Letter

- 0-9

- Symbol

- All friends

[clearstatcache]

hehehe....i misunderstood it.....

 

try ds 1..

users.displayName REGEXP '^\W'

 

[clearstatcache]

try ds also...

 

users.displayName REGEXP '^[^((a-z)|(0-9))]'

 

[The Little Guy]

OK... Here is what I have:

 

<?php
$letter = addslashes($_GET['lett']);
if($letter != '0-9' || $letter != 'symbol'){
$query = "SELECT * FROM friends_friends,users
WHERE
friends_friends.friend = '1'
AND
(friends_friends.myFriend = '$id' OR friends_friends.theirFriend = '$id')
AND
IFNULL(users.displayName LIKE '$letter%', users.fname LIKE '$letter%')
AND
((friends_friends.theirFriend = users.id AND friends_friends.theirFriend != '$id') OR (friends_friends.myFriend = users.id AND friends_friends.myFriend !='$id'))
ORDER BY addDate";
}elseif($letter == 'symbol'){
$query = "SELECT * FROM friends_friends,users
WHERE
IFNULL(users.displayName REGEXP '^[^((a-z)|(0-9))]', users.fname REGEXP '^[^((a-z)|(0-9))]')
AND
friends_friends.friend = '1'
AND
(friends_friends.myFriend = '$id' OR friends_friends.theirFriend = '$id')
AND
((friends_friends.theirFriend = users.id AND friends_friends.theirFriend != '$id') OR (friends_friends.myFriend = users.id AND friends_friends.myFriend !='$id'))
ORDER BY addDate";
}else{
$query = "SELECT * FROM friends_friends,users
WHERE
friends_friends.friend = '1'
AND
(friends_friends.myFriend = '$id' OR friends_friends.theirFriend = '$id')
AND
IFNULL(users.displayName REGEXP '^[0-9]', users.fname REGEXP '^[0-9]')
AND
((friends_friends.theirFriend = users.id AND friends_friends.theirFriend != '$id') OR (friends_friends.myFriend = users.id AND friends_friends.myFriend !='$id'))
ORDER BY addDate";
}
?>

[clearstatcache]

whats the result of the code?

did u get wat u want..?

[The Little Guy]

yes, except when I am doing a symbol search.

 

I can search by letter, and by numbers, but not symbols, unless I type the symbol in the address bar.

these all work:

http://publicsize.com/friends/viewFriends?action=letter&lett=#

http://publicsize.com/friends/viewFriends?action=letter&lett=$

http://publicsize.com/friends/viewFriends?action=letter&lett=1

http://publicsize.com/friends/viewFriends?action=letter&lett=8

http://publicsize.com/friends/viewFriends?action=letter&lett=g

http://publicsize.com/friends/viewFriends?action=letter&lett=k

 

But this doesn't:

 

http://publicsize.com/friends/viewFriends?action=letter&lett=symbol

 

I want the above ^^^ URL to search for all types of symbols like these: !@#$%^&*(){}|[]\;':",./<>?`~+.

[clearstatcache]

have u tried ds...?

    users.displayName REGEXP '^\W'

if still won't work...bwt ds 1....

    users.displayName REGEXP '^\pS'

[clearstatcache]

how was it little guy.....