Ceriwis

Ceriwis (https://forum.ceriwis.com/forum.php)
-   Programming (https://forum.ceriwis.com/forumdisplay.php?f=63)
-   -   Help SQL (https://forum.ceriwis.com/showthread.php?t=538410)

Braincode 11th November 2011 01:17 PM

Help SQL
 

gw ada 1 table



id | nama | nilai

----------------------

1 | ali | 8

2 | mike john | 7

3 | steve | 9

4 | yuli | 6

5 | Dave Li | 7

6 | lina | 10

7 | Alice Keys | 10

8 | marylin | 8





gw mao dengan kata kunci nama 'Li'



kan codingnya




PHP Code:




select * from table where nama LIKE '%li%'









nah gimana biar hasilnya urut

yg pertama kluar yg paling mendekati yi LIna



1. lina

2. ali

3. alice

4. yuli

5. marylin

6. Dave Li

</div>


All times are GMT +7. The time now is 04:47 PM.