sql help.......................... (Y)

[ad.hasareli]

me query 2 wenasa poddak pehedili karanawada ????


SELECT foo FROM bar WHERE foobar='$foo'

and

SELECT foo FROM bar WHERE foobar LIKE'$foo'

 

[NO_MeRcY]

http://stackoverflow.com/questions/1504990/whats-the-difference-between-like-and-in-sql

 

[ad.hasareli]

http://stackoverflow.com/questions/1504990/whats-the-difference-between-like-and-in-sql

thnx buddy 3+++

 

[ad.hasareli]

bmp

 

[c.j.c]

bmp

 

[c.j.c]

bump

 

[c.j.c]

bump

 

[c.j.c]

bump

 

[c.j.c]

bump

 

[maxboysl]

bmp

 

[ad.hasareli]

bmp

 

[ad.hasareli]

 

[niruthsg]

LIKE eken apita wildcard search karann puluwan... ehema nethuwa WHERE = "###" eken wenne ### kiyana eka search wena eka witharai.. LIKE eken apita range ekak unath hoyanna puluwan..

 

[ad.hasareli]

LIKE eken apita wildcard search karann puluwan... ehema nethuwa WHERE = "###" eken wenne ### kiyana eka search wena eka witharai.. LIKE eken apita range ekak unath hoyanna puluwan..

SELECT foo FROM bar WHERE foobar='xxxxx'
me query akata unath "=" wenuwata like use karanna puluwan neda machan ??

 

[niruthsg]

SELECT foo FROM bar WHERE foobar='xxxxx'
me query akata unath "=" wenuwata like use karanna puluwan neda machan ??

ow mchan.. LIKE eken apita godak dewal serach karaganna puluwan...

 

[ad.hasareli]

ow mchan.. LIKE eken apita godak dewal serach karaganna puluwan...

thnx machan 3+++