title: Load Local Data Infile with a condition in MYSQL 5.0
body: <p>I am having a question. 
  I have to upload a file into mysql 5.0 DB. 
  but inside the file it has 2 kinds of information, details and header. 
  it is like </p>
  
  <p>H12345678900TYPE 
  L12334567TYPE </p>
  
  <p>and the file is not delimited, it is fixed position. </p>
  
  <p>I want to load the lines which starts with H only and also has the type as TYPE. </p>
  
  <p>is there anyway I can check inside the load query? </p>
  
  <p>i tried <code>WHERE SUBSTR(@var1,1,1)='H'</code> </p>
  
  <p>but it says the syntax error. </p>
  
  <p>Any suggestion??? </p>
  
  <p>Thanks</p>