select term,locate(' ',term) ,locate(term,' ',1)
from table
-->
"Arthrocnodax rhoinus Felt, 1908","13","0"
The last should be 12 or !?....
ahh forget it, it should be:
Code:
select term,locate(' ',term) ,locate(' ',term,1)
__________________
Found a flower or bug and don't know what it is ? agrozoo.net galery
if you don't spot search button at once, there is search form: agrozoo.net galery search
Last edited by BubikolRamios; 01-02-2013 at 11:22 AM..