goma smile Posted April 10, 2011 Report Share Posted April 10, 2011 Kā var uztasīt ka filtrē pēc pirmā burta... ? Piemēram ir lietotāju lapa un ciņa ir sadalīta pēc pirmajiem burtiem un uzpiežot uz attiecīgo burtu E atverās visi kas sākas ar E Cik sapratu tas ir kaut kas querijā ? Quote Link to comment Share on other sites More sharing options...
rATRIJS Posted April 10, 2011 Report Share Posted April 10, 2011 (edited) WHERE field LIKE 'e%' http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html Edited April 10, 2011 by rATRIJS Quote Link to comment Share on other sites More sharing options...
goma smile Posted April 10, 2011 Author Report Share Posted April 10, 2011 paldies Quote Link to comment Share on other sites More sharing options...
wintermute Posted April 10, 2011 Report Share Posted April 10, 2011 Izmantojot SUBSTRING() metodi. Darbojas visās populārajās SQL datubāzēs. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.