Forum

Epilogi apo database ana gramma... - Από {dm}

Mipos xeri kapios na mou pi pos mporo na epilego stoixeia apo ena database ana gramma? Diladi pos mporo na oriso na epilexei ola ta onoma pou arxizoun apo a,b,c.. ktl?

Euxaristo!

Απάντηση από:qasw

TO OLO THEMA EINAI STH SYNTAXI THS PROTASHS SQL POY THA EKTELESHS.
P.X. THES NA EPILEKSEIS OLA TA ONOMATA POY ARXIZOYN APO "a", H SQL THA PREPEI NA EINAI :
SELECT ONOMA FROM PINAKA WHERE ONOMA LIKE "a%".
OMOIS THA MPOROYSES NA ANAZHTHSEIS ONOMATA POY ARXIZOYN APO b :
SELECT ONOMA FROM PINAKA WHERE ONOMA LIKE "b%".
TO % SHMAINEI OTIDHPOTE...